Automatic Data Migration between Two Databases with Different Structure

The process of data migration is one of the major challenges in the database structure development and improvement. The huge size of databases and the difference in syntax and semantics of tables are some of the crucial problems in data migration field. Data migration is performed in two phases sequentially: structure mapping and migration. In traditional approach, the first phase is carried out by the use of human experts, and the second phase is done by a software. In new data migrating approaches, the process is carried out automatically by the use of ontology in the first phase. In this paper with studying various methods in this field, a new model for migrating data between two databases with a different structure is proposed. By reviewing the existing models for traditional and semantic databases, the proposed model focuses on data migration between two traditional and semantic databases. In this model, data migration process is carried out by creating a middle layer. Covering both semantic and traditional databases is one of the most important features of proposed model.